﻿CREATE TABLE MessagesSent (
idMessage int IDENTITY(1,1) CONSTRAINT MessageSentPK PRIMARY KEY,
idService int NOT NULL,
sentDate datetime NOT NULL,
message ntext NOT NULL
)
;
CREATE TABLE RecipientsForMessagesSent (
idRecipient int IDENTITY(1,1) CONSTRAINT RecipientsForMessagesSentPK PRIMARY KEY,
idMessageSent int NOT NULL,
label nvarchar(50) NOT NULL,
value nvarchar(50) NOT NULL
)
;
CREATE TABLE LastMessageSent (
idService int CONSTRAINT LastMessageSentPK PRIMARY KEY,
idMessage int,
saved bit NOT NULL
)
;
INSERT INTO Config (ckey, cvalue) VALUES ('_build_of_', '20080518')